package com.ygqh.baby.po;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class YgProductExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public YgProductExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNull() {
            addCriterion("product_code is null");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNotNull() {
            addCriterion("product_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductCodeEqualTo(String value) {
            addCriterion("product_code =", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotEqualTo(String value) {
            addCriterion("product_code <>", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThan(String value) {
            addCriterion("product_code >", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThanOrEqualTo(String value) {
            addCriterion("product_code >=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThan(String value) {
            addCriterion("product_code <", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThanOrEqualTo(String value) {
            addCriterion("product_code <=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLike(String value) {
            addCriterion("product_code like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotLike(String value) {
            addCriterion("product_code not like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeIn(List<String> values) {
            addCriterion("product_code in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotIn(List<String> values) {
            addCriterion("product_code not in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeBetween(String value1, String value2) {
            addCriterion("product_code between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotBetween(String value1, String value2) {
            addCriterion("product_code not between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNull() {
            addCriterion("product_name is null");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNotNull() {
            addCriterion("product_name is not null");
            return (Criteria) this;
        }

        public Criteria andProductNameEqualTo(String value) {
            addCriterion("product_name =", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotEqualTo(String value) {
            addCriterion("product_name <>", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThan(String value) {
            addCriterion("product_name >", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThanOrEqualTo(String value) {
            addCriterion("product_name >=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThan(String value) {
            addCriterion("product_name <", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThanOrEqualTo(String value) {
            addCriterion("product_name <=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLike(String value) {
            addCriterion("product_name like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotLike(String value) {
            addCriterion("product_name not like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameIn(List<String> values) {
            addCriterion("product_name in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotIn(List<String> values) {
            addCriterion("product_name not in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameBetween(String value1, String value2) {
            addCriterion("product_name between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotBetween(String value1, String value2) {
            addCriterion("product_name not between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andProductTypeIsNull() {
            addCriterion("product_type is null");
            return (Criteria) this;
        }

        public Criteria andProductTypeIsNotNull() {
            addCriterion("product_type is not null");
            return (Criteria) this;
        }

        public Criteria andProductTypeEqualTo(String value) {
            addCriterion("product_type =", value, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeNotEqualTo(String value) {
            addCriterion("product_type <>", value, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeGreaterThan(String value) {
            addCriterion("product_type >", value, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeGreaterThanOrEqualTo(String value) {
            addCriterion("product_type >=", value, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeLessThan(String value) {
            addCriterion("product_type <", value, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeLessThanOrEqualTo(String value) {
            addCriterion("product_type <=", value, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeLike(String value) {
            addCriterion("product_type like", value, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeNotLike(String value) {
            addCriterion("product_type not like", value, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeIn(List<String> values) {
            addCriterion("product_type in", values, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeNotIn(List<String> values) {
            addCriterion("product_type not in", values, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeBetween(String value1, String value2) {
            addCriterion("product_type between", value1, value2, "productType");
            return (Criteria) this;
        }

        public Criteria andProductTypeNotBetween(String value1, String value2) {
            addCriterion("product_type not between", value1, value2, "productType");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceIsNull() {
            addCriterion("product_original_price is null");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceIsNotNull() {
            addCriterion("product_original_price is not null");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceEqualTo(BigDecimal value) {
            addCriterion("product_original_price =", value, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceNotEqualTo(BigDecimal value) {
            addCriterion("product_original_price <>", value, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceGreaterThan(BigDecimal value) {
            addCriterion("product_original_price >", value, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("product_original_price >=", value, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceLessThan(BigDecimal value) {
            addCriterion("product_original_price <", value, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("product_original_price <=", value, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceIn(List<BigDecimal> values) {
            addCriterion("product_original_price in", values, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceNotIn(List<BigDecimal> values) {
            addCriterion("product_original_price not in", values, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_original_price between", value1, value2, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductOriginalPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_original_price not between", value1, value2, "productOriginalPrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceIsNull() {
            addCriterion("product_sale_price is null");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceIsNotNull() {
            addCriterion("product_sale_price is not null");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceEqualTo(BigDecimal value) {
            addCriterion("product_sale_price =", value, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceNotEqualTo(BigDecimal value) {
            addCriterion("product_sale_price <>", value, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceGreaterThan(BigDecimal value) {
            addCriterion("product_sale_price >", value, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("product_sale_price >=", value, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceLessThan(BigDecimal value) {
            addCriterion("product_sale_price <", value, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("product_sale_price <=", value, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceIn(List<BigDecimal> values) {
            addCriterion("product_sale_price in", values, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceNotIn(List<BigDecimal> values) {
            addCriterion("product_sale_price not in", values, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_sale_price between", value1, value2, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andProductSalePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_sale_price not between", value1, value2, "productSalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceIsNull() {
            addCriterion("wholesale_price is null");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceIsNotNull() {
            addCriterion("wholesale_price is not null");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceEqualTo(BigDecimal value) {
            addCriterion("wholesale_price =", value, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceNotEqualTo(BigDecimal value) {
            addCriterion("wholesale_price <>", value, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceGreaterThan(BigDecimal value) {
            addCriterion("wholesale_price >", value, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("wholesale_price >=", value, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceLessThan(BigDecimal value) {
            addCriterion("wholesale_price <", value, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("wholesale_price <=", value, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceIn(List<BigDecimal> values) {
            addCriterion("wholesale_price in", values, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceNotIn(List<BigDecimal> values) {
            addCriterion("wholesale_price not in", values, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("wholesale_price between", value1, value2, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andWholesalePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("wholesale_price not between", value1, value2, "wholesalePrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceIsNull() {
            addCriterion("distribution_price is null");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceIsNotNull() {
            addCriterion("distribution_price is not null");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceEqualTo(BigDecimal value) {
            addCriterion("distribution_price =", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceNotEqualTo(BigDecimal value) {
            addCriterion("distribution_price <>", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceGreaterThan(BigDecimal value) {
            addCriterion("distribution_price >", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("distribution_price >=", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceLessThan(BigDecimal value) {
            addCriterion("distribution_price <", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("distribution_price <=", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceIn(List<BigDecimal> values) {
            addCriterion("distribution_price in", values, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceNotIn(List<BigDecimal> values) {
            addCriterion("distribution_price not in", values, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("distribution_price between", value1, value2, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("distribution_price not between", value1, value2, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNull() {
            addCriterion("brand_id is null");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNotNull() {
            addCriterion("brand_id is not null");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualTo(Long value) {
            addCriterion("brand_id =", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualTo(Long value) {
            addCriterion("brand_id <>", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThan(Long value) {
            addCriterion("brand_id >", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualTo(Long value) {
            addCriterion("brand_id >=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThan(Long value) {
            addCriterion("brand_id <", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualTo(Long value) {
            addCriterion("brand_id <=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdIn(List<Long> values) {
            addCriterion("brand_id in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotIn(List<Long> values) {
            addCriterion("brand_id not in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdBetween(Long value1, Long value2) {
            addCriterion("brand_id between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotBetween(Long value1, Long value2) {
            addCriterion("brand_id not between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andGroupIdIsNull() {
            addCriterion("group_id is null");
            return (Criteria) this;
        }

        public Criteria andGroupIdIsNotNull() {
            addCriterion("group_id is not null");
            return (Criteria) this;
        }

        public Criteria andGroupIdEqualTo(Long value) {
            addCriterion("group_id =", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdNotEqualTo(Long value) {
            addCriterion("group_id <>", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdGreaterThan(Long value) {
            addCriterion("group_id >", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdGreaterThanOrEqualTo(Long value) {
            addCriterion("group_id >=", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdLessThan(Long value) {
            addCriterion("group_id <", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdLessThanOrEqualTo(Long value) {
            addCriterion("group_id <=", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdIn(List<Long> values) {
            addCriterion("group_id in", values, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdNotIn(List<Long> values) {
            addCriterion("group_id not in", values, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdBetween(Long value1, Long value2) {
            addCriterion("group_id between", value1, value2, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdNotBetween(Long value1, Long value2) {
            addCriterion("group_id not between", value1, value2, "groupId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNull() {
            addCriterion("category_id is null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNotNull() {
            addCriterion("category_id is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdEqualTo(Long value) {
            addCriterion("category_id =", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotEqualTo(Long value) {
            addCriterion("category_id <>", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThan(Long value) {
            addCriterion("category_id >", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThanOrEqualTo(Long value) {
            addCriterion("category_id >=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThan(Long value) {
            addCriterion("category_id <", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThanOrEqualTo(Long value) {
            addCriterion("category_id <=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIn(List<Long> values) {
            addCriterion("category_id in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotIn(List<Long> values) {
            addCriterion("category_id not in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdBetween(Long value1, Long value2) {
            addCriterion("category_id between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotBetween(Long value1, Long value2) {
            addCriterion("category_id not between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNull() {
            addCriterion("supplier_id is null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNotNull() {
            addCriterion("supplier_id is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdEqualTo(Long value) {
            addCriterion("supplier_id =", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotEqualTo(Long value) {
            addCriterion("supplier_id <>", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThan(Long value) {
            addCriterion("supplier_id >", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThanOrEqualTo(Long value) {
            addCriterion("supplier_id >=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThan(Long value) {
            addCriterion("supplier_id <", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThanOrEqualTo(Long value) {
            addCriterion("supplier_id <=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIn(List<Long> values) {
            addCriterion("supplier_id in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotIn(List<Long> values) {
            addCriterion("supplier_id not in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdBetween(Long value1, Long value2) {
            addCriterion("supplier_id between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotBetween(Long value1, Long value2) {
            addCriterion("supplier_id not between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andStyleIdIsNull() {
            addCriterion("style_id is null");
            return (Criteria) this;
        }

        public Criteria andStyleIdIsNotNull() {
            addCriterion("style_id is not null");
            return (Criteria) this;
        }

        public Criteria andStyleIdEqualTo(Long value) {
            addCriterion("style_id =", value, "styleId");
            return (Criteria) this;
        }

        public Criteria andStyleIdNotEqualTo(Long value) {
            addCriterion("style_id <>", value, "styleId");
            return (Criteria) this;
        }

        public Criteria andStyleIdGreaterThan(Long value) {
            addCriterion("style_id >", value, "styleId");
            return (Criteria) this;
        }

        public Criteria andStyleIdGreaterThanOrEqualTo(Long value) {
            addCriterion("style_id >=", value, "styleId");
            return (Criteria) this;
        }

        public Criteria andStyleIdLessThan(Long value) {
            addCriterion("style_id <", value, "styleId");
            return (Criteria) this;
        }

        public Criteria andStyleIdLessThanOrEqualTo(Long value) {
            addCriterion("style_id <=", value, "styleId");
            return (Criteria) this;
        }

        public Criteria andStyleIdIn(List<Long> values) {
            addCriterion("style_id in", values, "styleId");
            return (Criteria) this;
        }

        public Criteria andStyleIdNotIn(List<Long> values) {
            addCriterion("style_id not in", values, "styleId");
            return (Criteria) this;
        }

        public Criteria andStyleIdBetween(Long value1, Long value2) {
            addCriterion("style_id between", value1, value2, "styleId");
            return (Criteria) this;
        }

        public Criteria andStyleIdNotBetween(Long value1, Long value2) {
            addCriterion("style_id not between", value1, value2, "styleId");
            return (Criteria) this;
        }

        public Criteria andGenderIsNull() {
            addCriterion("gender is null");
            return (Criteria) this;
        }

        public Criteria andGenderIsNotNull() {
            addCriterion("gender is not null");
            return (Criteria) this;
        }

        public Criteria andGenderEqualTo(String value) {
            addCriterion("gender =", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotEqualTo(String value) {
            addCriterion("gender <>", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThan(String value) {
            addCriterion("gender >", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThanOrEqualTo(String value) {
            addCriterion("gender >=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThan(String value) {
            addCriterion("gender <", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThanOrEqualTo(String value) {
            addCriterion("gender <=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLike(String value) {
            addCriterion("gender like", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotLike(String value) {
            addCriterion("gender not like", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderIn(List<String> values) {
            addCriterion("gender in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotIn(List<String> values) {
            addCriterion("gender not in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderBetween(String value1, String value2) {
            addCriterion("gender between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotBetween(String value1, String value2) {
            addCriterion("gender not between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andUnitNameIsNull() {
            addCriterion("unit_name is null");
            return (Criteria) this;
        }

        public Criteria andUnitNameIsNotNull() {
            addCriterion("unit_name is not null");
            return (Criteria) this;
        }

        public Criteria andUnitNameEqualTo(String value) {
            addCriterion("unit_name =", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotEqualTo(String value) {
            addCriterion("unit_name <>", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameGreaterThan(String value) {
            addCriterion("unit_name >", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameGreaterThanOrEqualTo(String value) {
            addCriterion("unit_name >=", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameLessThan(String value) {
            addCriterion("unit_name <", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameLessThanOrEqualTo(String value) {
            addCriterion("unit_name <=", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameLike(String value) {
            addCriterion("unit_name like", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotLike(String value) {
            addCriterion("unit_name not like", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameIn(List<String> values) {
            addCriterion("unit_name in", values, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotIn(List<String> values) {
            addCriterion("unit_name not in", values, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameBetween(String value1, String value2) {
            addCriterion("unit_name between", value1, value2, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotBetween(String value1, String value2) {
            addCriterion("unit_name not between", value1, value2, "unitName");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathIsNull() {
            addCriterion("detail_image_path is null");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathIsNotNull() {
            addCriterion("detail_image_path is not null");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathEqualTo(String value) {
            addCriterion("detail_image_path =", value, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathNotEqualTo(String value) {
            addCriterion("detail_image_path <>", value, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathGreaterThan(String value) {
            addCriterion("detail_image_path >", value, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathGreaterThanOrEqualTo(String value) {
            addCriterion("detail_image_path >=", value, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathLessThan(String value) {
            addCriterion("detail_image_path <", value, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathLessThanOrEqualTo(String value) {
            addCriterion("detail_image_path <=", value, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathLike(String value) {
            addCriterion("detail_image_path like", value, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathNotLike(String value) {
            addCriterion("detail_image_path not like", value, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathIn(List<String> values) {
            addCriterion("detail_image_path in", values, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathNotIn(List<String> values) {
            addCriterion("detail_image_path not in", values, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathBetween(String value1, String value2) {
            addCriterion("detail_image_path between", value1, value2, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andDetailImagePathNotBetween(String value1, String value2) {
            addCriterion("detail_image_path not between", value1, value2, "detailImagePath");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andSaleStatusIsNull() {
            addCriterion("sale_status is null");
            return (Criteria) this;
        }

        public Criteria andSaleStatusIsNotNull() {
            addCriterion("sale_status is not null");
            return (Criteria) this;
        }

        public Criteria andSaleStatusEqualTo(String value) {
            addCriterion("sale_status =", value, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusNotEqualTo(String value) {
            addCriterion("sale_status <>", value, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusGreaterThan(String value) {
            addCriterion("sale_status >", value, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusGreaterThanOrEqualTo(String value) {
            addCriterion("sale_status >=", value, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusLessThan(String value) {
            addCriterion("sale_status <", value, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusLessThanOrEqualTo(String value) {
            addCriterion("sale_status <=", value, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusLike(String value) {
            addCriterion("sale_status like", value, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusNotLike(String value) {
            addCriterion("sale_status not like", value, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusIn(List<String> values) {
            addCriterion("sale_status in", values, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusNotIn(List<String> values) {
            addCriterion("sale_status not in", values, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusBetween(String value1, String value2) {
            addCriterion("sale_status between", value1, value2, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andSaleStatusNotBetween(String value1, String value2) {
            addCriterion("sale_status not between", value1, value2, "saleStatus");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateIsNull() {
            addCriterion("pre_sale_date is null");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateIsNotNull() {
            addCriterion("pre_sale_date is not null");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateEqualTo(Date value) {
            addCriterionForJDBCDate("pre_sale_date =", value, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("pre_sale_date <>", value, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateGreaterThan(Date value) {
            addCriterionForJDBCDate("pre_sale_date >", value, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("pre_sale_date >=", value, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateLessThan(Date value) {
            addCriterionForJDBCDate("pre_sale_date <", value, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("pre_sale_date <=", value, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateIn(List<Date> values) {
            addCriterionForJDBCDate("pre_sale_date in", values, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("pre_sale_date not in", values, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("pre_sale_date between", value1, value2, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andPreSaleDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("pre_sale_date not between", value1, value2, "preSaleDate");
            return (Criteria) this;
        }

        public Criteria andSaleTimeIsNull() {
            addCriterion("sale_time is null");
            return (Criteria) this;
        }

        public Criteria andSaleTimeIsNotNull() {
            addCriterion("sale_time is not null");
            return (Criteria) this;
        }

        public Criteria andSaleTimeEqualTo(Date value) {
            addCriterion("sale_time =", value, "saleTime");
            return (Criteria) this;
        }

        public Criteria andSaleTimeNotEqualTo(Date value) {
            addCriterion("sale_time <>", value, "saleTime");
            return (Criteria) this;
        }

        public Criteria andSaleTimeGreaterThan(Date value) {
            addCriterion("sale_time >", value, "saleTime");
            return (Criteria) this;
        }

        public Criteria andSaleTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("sale_time >=", value, "saleTime");
            return (Criteria) this;
        }

        public Criteria andSaleTimeLessThan(Date value) {
            addCriterion("sale_time <", value, "saleTime");
            return (Criteria) this;
        }

        public Criteria andSaleTimeLessThanOrEqualTo(Date value) {
            addCriterion("sale_time <=", value, "saleTime");
            return (Criteria) this;
        }

        public Criteria andSaleTimeIn(List<Date> values) {
            addCriterion("sale_time in", values, "saleTime");
            return (Criteria) this;
        }

        public Criteria andSaleTimeNotIn(List<Date> values) {
            addCriterion("sale_time not in", values, "saleTime");
            return (Criteria) this;
        }

        public Criteria andSaleTimeBetween(Date value1, Date value2) {
            addCriterion("sale_time between", value1, value2, "saleTime");
            return (Criteria) this;
        }

        public Criteria andSaleTimeNotBetween(Date value1, Date value2) {
            addCriterion("sale_time not between", value1, value2, "saleTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(String value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(String value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(String value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(String value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLike(String value) {
            addCriterion("create_by like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotLike(String value) {
            addCriterion("create_by not like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<String> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<String> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(String value1, String value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("update_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("update_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(String value) {
            addCriterion("update_by =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(String value) {
            addCriterion("update_by <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(String value) {
            addCriterion("update_by >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("update_by >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(String value) {
            addCriterion("update_by <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("update_by <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLike(String value) {
            addCriterion("update_by like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotLike(String value) {
            addCriterion("update_by not like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<String> values) {
            addCriterion("update_by in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<String> values) {
            addCriterion("update_by not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(String value1, String value2) {
            addCriterion("update_by between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("update_by not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNull() {
            addCriterion("short_name is null");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNotNull() {
            addCriterion("short_name is not null");
            return (Criteria) this;
        }

        public Criteria andShortNameEqualTo(String value) {
            addCriterion("short_name =", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotEqualTo(String value) {
            addCriterion("short_name <>", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThan(String value) {
            addCriterion("short_name >", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThanOrEqualTo(String value) {
            addCriterion("short_name >=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThan(String value) {
            addCriterion("short_name <", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThanOrEqualTo(String value) {
            addCriterion("short_name <=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLike(String value) {
            addCriterion("short_name like", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotLike(String value) {
            addCriterion("short_name not like", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameIn(List<String> values) {
            addCriterion("short_name in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotIn(List<String> values) {
            addCriterion("short_name not in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameBetween(String value1, String value2) {
            addCriterion("short_name between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotBetween(String value1, String value2) {
            addCriterion("short_name not between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeIsNull() {
            addCriterion("promotion_type is null");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeIsNotNull() {
            addCriterion("promotion_type is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeEqualTo(String value) {
            addCriterion("promotion_type =", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeNotEqualTo(String value) {
            addCriterion("promotion_type <>", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeGreaterThan(String value) {
            addCriterion("promotion_type >", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeGreaterThanOrEqualTo(String value) {
            addCriterion("promotion_type >=", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeLessThan(String value) {
            addCriterion("promotion_type <", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeLessThanOrEqualTo(String value) {
            addCriterion("promotion_type <=", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeLike(String value) {
            addCriterion("promotion_type like", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeNotLike(String value) {
            addCriterion("promotion_type not like", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeIn(List<String> values) {
            addCriterion("promotion_type in", values, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeNotIn(List<String> values) {
            addCriterion("promotion_type not in", values, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeBetween(String value1, String value2) {
            addCriterion("promotion_type between", value1, value2, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeNotBetween(String value1, String value2) {
            addCriterion("promotion_type not between", value1, value2, "promotionType");
            return (Criteria) this;
        }

        public Criteria andIsSpecialIsNull() {
            addCriterion("is_special is null");
            return (Criteria) this;
        }

        public Criteria andIsSpecialIsNotNull() {
            addCriterion("is_special is not null");
            return (Criteria) this;
        }

        public Criteria andIsSpecialEqualTo(Boolean value) {
            addCriterion("is_special =", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialNotEqualTo(Boolean value) {
            addCriterion("is_special <>", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialGreaterThan(Boolean value) {
            addCriterion("is_special >", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_special >=", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialLessThan(Boolean value) {
            addCriterion("is_special <", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialLessThanOrEqualTo(Boolean value) {
            addCriterion("is_special <=", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialIn(List<Boolean> values) {
            addCriterion("is_special in", values, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialNotIn(List<Boolean> values) {
            addCriterion("is_special not in", values, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialBetween(Boolean value1, Boolean value2) {
            addCriterion("is_special between", value1, value2, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_special not between", value1, value2, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceIsNull() {
            addCriterion("new_custom_price is null");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceIsNotNull() {
            addCriterion("new_custom_price is not null");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceEqualTo(BigDecimal value) {
            addCriterion("new_custom_price =", value, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceNotEqualTo(BigDecimal value) {
            addCriterion("new_custom_price <>", value, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceGreaterThan(BigDecimal value) {
            addCriterion("new_custom_price >", value, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("new_custom_price >=", value, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceLessThan(BigDecimal value) {
            addCriterion("new_custom_price <", value, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("new_custom_price <=", value, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceIn(List<BigDecimal> values) {
            addCriterion("new_custom_price in", values, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceNotIn(List<BigDecimal> values) {
            addCriterion("new_custom_price not in", values, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("new_custom_price between", value1, value2, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("new_custom_price not between", value1, value2, "newCustomPrice");
            return (Criteria) this;
        }

        public Criteria andSaleNumIsNull() {
            addCriterion("sale_num is null");
            return (Criteria) this;
        }

        public Criteria andSaleNumIsNotNull() {
            addCriterion("sale_num is not null");
            return (Criteria) this;
        }

        public Criteria andSaleNumEqualTo(Long value) {
            addCriterion("sale_num =", value, "saleNum");
            return (Criteria) this;
        }

        public Criteria andSaleNumNotEqualTo(Long value) {
            addCriterion("sale_num <>", value, "saleNum");
            return (Criteria) this;
        }

        public Criteria andSaleNumGreaterThan(Long value) {
            addCriterion("sale_num >", value, "saleNum");
            return (Criteria) this;
        }

        public Criteria andSaleNumGreaterThanOrEqualTo(Long value) {
            addCriterion("sale_num >=", value, "saleNum");
            return (Criteria) this;
        }

        public Criteria andSaleNumLessThan(Long value) {
            addCriterion("sale_num <", value, "saleNum");
            return (Criteria) this;
        }

        public Criteria andSaleNumLessThanOrEqualTo(Long value) {
            addCriterion("sale_num <=", value, "saleNum");
            return (Criteria) this;
        }

        public Criteria andSaleNumIn(List<Long> values) {
            addCriterion("sale_num in", values, "saleNum");
            return (Criteria) this;
        }

        public Criteria andSaleNumNotIn(List<Long> values) {
            addCriterion("sale_num not in", values, "saleNum");
            return (Criteria) this;
        }

        public Criteria andSaleNumBetween(Long value1, Long value2) {
            addCriterion("sale_num between", value1, value2, "saleNum");
            return (Criteria) this;
        }

        public Criteria andSaleNumNotBetween(Long value1, Long value2) {
            addCriterion("sale_num not between", value1, value2, "saleNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumIsNull() {
            addCriterion("comment_num is null");
            return (Criteria) this;
        }

        public Criteria andCommentNumIsNotNull() {
            addCriterion("comment_num is not null");
            return (Criteria) this;
        }

        public Criteria andCommentNumEqualTo(Long value) {
            addCriterion("comment_num =", value, "commentNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumNotEqualTo(Long value) {
            addCriterion("comment_num <>", value, "commentNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumGreaterThan(Long value) {
            addCriterion("comment_num >", value, "commentNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumGreaterThanOrEqualTo(Long value) {
            addCriterion("comment_num >=", value, "commentNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumLessThan(Long value) {
            addCriterion("comment_num <", value, "commentNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumLessThanOrEqualTo(Long value) {
            addCriterion("comment_num <=", value, "commentNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumIn(List<Long> values) {
            addCriterion("comment_num in", values, "commentNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumNotIn(List<Long> values) {
            addCriterion("comment_num not in", values, "commentNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumBetween(Long value1, Long value2) {
            addCriterion("comment_num between", value1, value2, "commentNum");
            return (Criteria) this;
        }

        public Criteria andCommentNumNotBetween(Long value1, Long value2) {
            addCriterion("comment_num not between", value1, value2, "commentNum");
            return (Criteria) this;
        }

        public Criteria andTagsIsNull() {
            addCriterion("tags is null");
            return (Criteria) this;
        }

        public Criteria andTagsIsNotNull() {
            addCriterion("tags is not null");
            return (Criteria) this;
        }

        public Criteria andTagsEqualTo(String value) {
            addCriterion("tags =", value, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsNotEqualTo(String value) {
            addCriterion("tags <>", value, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsGreaterThan(String value) {
            addCriterion("tags >", value, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsGreaterThanOrEqualTo(String value) {
            addCriterion("tags >=", value, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsLessThan(String value) {
            addCriterion("tags <", value, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsLessThanOrEqualTo(String value) {
            addCriterion("tags <=", value, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsLike(String value) {
            addCriterion("tags like", value, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsNotLike(String value) {
            addCriterion("tags not like", value, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsIn(List<String> values) {
            addCriterion("tags in", values, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsNotIn(List<String> values) {
            addCriterion("tags not in", values, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsBetween(String value1, String value2) {
            addCriterion("tags between", value1, value2, "tags");
            return (Criteria) this;
        }

        public Criteria andTagsNotBetween(String value1, String value2) {
            addCriterion("tags not between", value1, value2, "tags");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceIsNull() {
            addCriterion("promotion_price is null");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceIsNotNull() {
            addCriterion("promotion_price is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceEqualTo(BigDecimal value) {
            addCriterion("promotion_price =", value, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceNotEqualTo(BigDecimal value) {
            addCriterion("promotion_price <>", value, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceGreaterThan(BigDecimal value) {
            addCriterion("promotion_price >", value, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("promotion_price >=", value, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceLessThan(BigDecimal value) {
            addCriterion("promotion_price <", value, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("promotion_price <=", value, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceIn(List<BigDecimal> values) {
            addCriterion("promotion_price in", values, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceNotIn(List<BigDecimal> values) {
            addCriterion("promotion_price not in", values, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("promotion_price between", value1, value2, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("promotion_price not between", value1, value2, "promotionPrice");
            return (Criteria) this;
        }

        public Criteria andTmallIdIsNull() {
            addCriterion("tmall_id is null");
            return (Criteria) this;
        }

        public Criteria andTmallIdIsNotNull() {
            addCriterion("tmall_id is not null");
            return (Criteria) this;
        }

        public Criteria andTmallIdEqualTo(Long value) {
            addCriterion("tmall_id =", value, "tmallId");
            return (Criteria) this;
        }

        public Criteria andTmallIdNotEqualTo(Long value) {
            addCriterion("tmall_id <>", value, "tmallId");
            return (Criteria) this;
        }

        public Criteria andTmallIdGreaterThan(Long value) {
            addCriterion("tmall_id >", value, "tmallId");
            return (Criteria) this;
        }

        public Criteria andTmallIdGreaterThanOrEqualTo(Long value) {
            addCriterion("tmall_id >=", value, "tmallId");
            return (Criteria) this;
        }

        public Criteria andTmallIdLessThan(Long value) {
            addCriterion("tmall_id <", value, "tmallId");
            return (Criteria) this;
        }

        public Criteria andTmallIdLessThanOrEqualTo(Long value) {
            addCriterion("tmall_id <=", value, "tmallId");
            return (Criteria) this;
        }

        public Criteria andTmallIdIn(List<Long> values) {
            addCriterion("tmall_id in", values, "tmallId");
            return (Criteria) this;
        }

        public Criteria andTmallIdNotIn(List<Long> values) {
            addCriterion("tmall_id not in", values, "tmallId");
            return (Criteria) this;
        }

        public Criteria andTmallIdBetween(Long value1, Long value2) {
            addCriterion("tmall_id between", value1, value2, "tmallId");
            return (Criteria) this;
        }

        public Criteria andTmallIdNotBetween(Long value1, Long value2) {
            addCriterion("tmall_id not between", value1, value2, "tmallId");
            return (Criteria) this;
        }

        public Criteria andVipPriceIsNull() {
            addCriterion("vip_price is null");
            return (Criteria) this;
        }

        public Criteria andVipPriceIsNotNull() {
            addCriterion("vip_price is not null");
            return (Criteria) this;
        }

        public Criteria andVipPriceEqualTo(BigDecimal value) {
            addCriterion("vip_price =", value, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andVipPriceNotEqualTo(BigDecimal value) {
            addCriterion("vip_price <>", value, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andVipPriceGreaterThan(BigDecimal value) {
            addCriterion("vip_price >", value, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andVipPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("vip_price >=", value, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andVipPriceLessThan(BigDecimal value) {
            addCriterion("vip_price <", value, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andVipPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("vip_price <=", value, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andVipPriceIn(List<BigDecimal> values) {
            addCriterion("vip_price in", values, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andVipPriceNotIn(List<BigDecimal> values) {
            addCriterion("vip_price not in", values, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andVipPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("vip_price between", value1, value2, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andVipPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("vip_price not between", value1, value2, "vipPrice");
            return (Criteria) this;
        }

        public Criteria andShareRateIsNull() {
            addCriterion("share_rate is null");
            return (Criteria) this;
        }

        public Criteria andShareRateIsNotNull() {
            addCriterion("share_rate is not null");
            return (Criteria) this;
        }

        public Criteria andShareRateEqualTo(BigDecimal value) {
            addCriterion("share_rate =", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateNotEqualTo(BigDecimal value) {
            addCriterion("share_rate <>", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateGreaterThan(BigDecimal value) {
            addCriterion("share_rate >", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("share_rate >=", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateLessThan(BigDecimal value) {
            addCriterion("share_rate <", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("share_rate <=", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateIn(List<BigDecimal> values) {
            addCriterion("share_rate in", values, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateNotIn(List<BigDecimal> values) {
            addCriterion("share_rate not in", values, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_rate between", value1, value2, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_rate not between", value1, value2, "shareRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateIsNull() {
            addCriterion("forever_rate is null");
            return (Criteria) this;
        }

        public Criteria andForeverRateIsNotNull() {
            addCriterion("forever_rate is not null");
            return (Criteria) this;
        }

        public Criteria andForeverRateEqualTo(BigDecimal value) {
            addCriterion("forever_rate =", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateNotEqualTo(BigDecimal value) {
            addCriterion("forever_rate <>", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateGreaterThan(BigDecimal value) {
            addCriterion("forever_rate >", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("forever_rate >=", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateLessThan(BigDecimal value) {
            addCriterion("forever_rate <", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("forever_rate <=", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateIn(List<BigDecimal> values) {
            addCriterion("forever_rate in", values, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateNotIn(List<BigDecimal> values) {
            addCriterion("forever_rate not in", values, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forever_rate between", value1, value2, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forever_rate not between", value1, value2, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeIsNull() {
            addCriterion("basic_attribute is null");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeIsNotNull() {
            addCriterion("basic_attribute is not null");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeEqualTo(String value) {
            addCriterion("basic_attribute =", value, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeNotEqualTo(String value) {
            addCriterion("basic_attribute <>", value, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeGreaterThan(String value) {
            addCriterion("basic_attribute >", value, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeGreaterThanOrEqualTo(String value) {
            addCriterion("basic_attribute >=", value, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeLessThan(String value) {
            addCriterion("basic_attribute <", value, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeLessThanOrEqualTo(String value) {
            addCriterion("basic_attribute <=", value, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeLike(String value) {
            addCriterion("basic_attribute like", value, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeNotLike(String value) {
            addCriterion("basic_attribute not like", value, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeIn(List<String> values) {
            addCriterion("basic_attribute in", values, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeNotIn(List<String> values) {
            addCriterion("basic_attribute not in", values, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeBetween(String value1, String value2) {
            addCriterion("basic_attribute between", value1, value2, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andBasicAttributeNotBetween(String value1, String value2) {
            addCriterion("basic_attribute not between", value1, value2, "basicAttribute");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesIsNull() {
            addCriterion("category_names is null");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesIsNotNull() {
            addCriterion("category_names is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesEqualTo(String value) {
            addCriterion("category_names =", value, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesNotEqualTo(String value) {
            addCriterion("category_names <>", value, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesGreaterThan(String value) {
            addCriterion("category_names >", value, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesGreaterThanOrEqualTo(String value) {
            addCriterion("category_names >=", value, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesLessThan(String value) {
            addCriterion("category_names <", value, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesLessThanOrEqualTo(String value) {
            addCriterion("category_names <=", value, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesLike(String value) {
            addCriterion("category_names like", value, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesNotLike(String value) {
            addCriterion("category_names not like", value, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesIn(List<String> values) {
            addCriterion("category_names in", values, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesNotIn(List<String> values) {
            addCriterion("category_names not in", values, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesBetween(String value1, String value2) {
            addCriterion("category_names between", value1, value2, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andCategoryNamesNotBetween(String value1, String value2) {
            addCriterion("category_names not between", value1, value2, "categoryNames");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformIsNull() {
            addCriterion("sales_platform is null");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformIsNotNull() {
            addCriterion("sales_platform is not null");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformEqualTo(String value) {
            addCriterion("sales_platform =", value, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformNotEqualTo(String value) {
            addCriterion("sales_platform <>", value, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformGreaterThan(String value) {
            addCriterion("sales_platform >", value, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformGreaterThanOrEqualTo(String value) {
            addCriterion("sales_platform >=", value, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformLessThan(String value) {
            addCriterion("sales_platform <", value, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformLessThanOrEqualTo(String value) {
            addCriterion("sales_platform <=", value, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformLike(String value) {
            addCriterion("sales_platform like", value, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformNotLike(String value) {
            addCriterion("sales_platform not like", value, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformIn(List<String> values) {
            addCriterion("sales_platform in", values, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformNotIn(List<String> values) {
            addCriterion("sales_platform not in", values, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformBetween(String value1, String value2) {
            addCriterion("sales_platform between", value1, value2, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSalesPlatformNotBetween(String value1, String value2) {
            addCriterion("sales_platform not between", value1, value2, "salesPlatform");
            return (Criteria) this;
        }

        public Criteria andSellingPointIsNull() {
            addCriterion("selling_point is null");
            return (Criteria) this;
        }

        public Criteria andSellingPointIsNotNull() {
            addCriterion("selling_point is not null");
            return (Criteria) this;
        }

        public Criteria andSellingPointEqualTo(String value) {
            addCriterion("selling_point =", value, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointNotEqualTo(String value) {
            addCriterion("selling_point <>", value, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointGreaterThan(String value) {
            addCriterion("selling_point >", value, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointGreaterThanOrEqualTo(String value) {
            addCriterion("selling_point >=", value, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointLessThan(String value) {
            addCriterion("selling_point <", value, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointLessThanOrEqualTo(String value) {
            addCriterion("selling_point <=", value, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointLike(String value) {
            addCriterion("selling_point like", value, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointNotLike(String value) {
            addCriterion("selling_point not like", value, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointIn(List<String> values) {
            addCriterion("selling_point in", values, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointNotIn(List<String> values) {
            addCriterion("selling_point not in", values, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointBetween(String value1, String value2) {
            addCriterion("selling_point between", value1, value2, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andSellingPointNotBetween(String value1, String value2) {
            addCriterion("selling_point not between", value1, value2, "sellingPoint");
            return (Criteria) this;
        }

        public Criteria andPushKidsIsNull() {
            addCriterion("push_kids is null");
            return (Criteria) this;
        }

        public Criteria andPushKidsIsNotNull() {
            addCriterion("push_kids is not null");
            return (Criteria) this;
        }

        public Criteria andPushKidsEqualTo(Boolean value) {
            addCriterion("push_kids =", value, "pushKids");
            return (Criteria) this;
        }

        public Criteria andPushKidsNotEqualTo(Boolean value) {
            addCriterion("push_kids <>", value, "pushKids");
            return (Criteria) this;
        }

        public Criteria andPushKidsGreaterThan(Boolean value) {
            addCriterion("push_kids >", value, "pushKids");
            return (Criteria) this;
        }

        public Criteria andPushKidsGreaterThanOrEqualTo(Boolean value) {
            addCriterion("push_kids >=", value, "pushKids");
            return (Criteria) this;
        }

        public Criteria andPushKidsLessThan(Boolean value) {
            addCriterion("push_kids <", value, "pushKids");
            return (Criteria) this;
        }

        public Criteria andPushKidsLessThanOrEqualTo(Boolean value) {
            addCriterion("push_kids <=", value, "pushKids");
            return (Criteria) this;
        }

        public Criteria andPushKidsIn(List<Boolean> values) {
            addCriterion("push_kids in", values, "pushKids");
            return (Criteria) this;
        }

        public Criteria andPushKidsNotIn(List<Boolean> values) {
            addCriterion("push_kids not in", values, "pushKids");
            return (Criteria) this;
        }

        public Criteria andPushKidsBetween(Boolean value1, Boolean value2) {
            addCriterion("push_kids between", value1, value2, "pushKids");
            return (Criteria) this;
        }

        public Criteria andPushKidsNotBetween(Boolean value1, Boolean value2) {
            addCriterion("push_kids not between", value1, value2, "pushKids");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateIsNull() {
            addCriterion("value_added_tax_rate is null");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateIsNotNull() {
            addCriterion("value_added_tax_rate is not null");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateEqualTo(BigDecimal value) {
            addCriterion("value_added_tax_rate =", value, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateNotEqualTo(BigDecimal value) {
            addCriterion("value_added_tax_rate <>", value, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateGreaterThan(BigDecimal value) {
            addCriterion("value_added_tax_rate >", value, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("value_added_tax_rate >=", value, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateLessThan(BigDecimal value) {
            addCriterion("value_added_tax_rate <", value, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("value_added_tax_rate <=", value, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateIn(List<BigDecimal> values) {
            addCriterion("value_added_tax_rate in", values, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateNotIn(List<BigDecimal> values) {
            addCriterion("value_added_tax_rate not in", values, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("value_added_tax_rate between", value1, value2, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andValueAddedTaxRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("value_added_tax_rate not between", value1, value2, "valueAddedTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateIsNull() {
            addCriterion("sale_tax_rate is null");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateIsNotNull() {
            addCriterion("sale_tax_rate is not null");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateEqualTo(BigDecimal value) {
            addCriterion("sale_tax_rate =", value, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateNotEqualTo(BigDecimal value) {
            addCriterion("sale_tax_rate <>", value, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateGreaterThan(BigDecimal value) {
            addCriterion("sale_tax_rate >", value, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("sale_tax_rate >=", value, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateLessThan(BigDecimal value) {
            addCriterion("sale_tax_rate <", value, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("sale_tax_rate <=", value, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateIn(List<BigDecimal> values) {
            addCriterion("sale_tax_rate in", values, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateNotIn(List<BigDecimal> values) {
            addCriterion("sale_tax_rate not in", values, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sale_tax_rate between", value1, value2, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andSaleTaxRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sale_tax_rate not between", value1, value2, "saleTaxRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateIsNull() {
            addCriterion("tariff_rate is null");
            return (Criteria) this;
        }

        public Criteria andTariffRateIsNotNull() {
            addCriterion("tariff_rate is not null");
            return (Criteria) this;
        }

        public Criteria andTariffRateEqualTo(BigDecimal value) {
            addCriterion("tariff_rate =", value, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateNotEqualTo(BigDecimal value) {
            addCriterion("tariff_rate <>", value, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateGreaterThan(BigDecimal value) {
            addCriterion("tariff_rate >", value, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("tariff_rate >=", value, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateLessThan(BigDecimal value) {
            addCriterion("tariff_rate <", value, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("tariff_rate <=", value, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateIn(List<BigDecimal> values) {
            addCriterion("tariff_rate in", values, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateNotIn(List<BigDecimal> values) {
            addCriterion("tariff_rate not in", values, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tariff_rate between", value1, value2, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andTariffRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tariff_rate not between", value1, value2, "tariffRate");
            return (Criteria) this;
        }

        public Criteria andPromotionTagIsNull() {
            addCriterion("promotion_tag is null");
            return (Criteria) this;
        }

        public Criteria andPromotionTagIsNotNull() {
            addCriterion("promotion_tag is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionTagEqualTo(String value) {
            addCriterion("promotion_tag =", value, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagNotEqualTo(String value) {
            addCriterion("promotion_tag <>", value, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagGreaterThan(String value) {
            addCriterion("promotion_tag >", value, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagGreaterThanOrEqualTo(String value) {
            addCriterion("promotion_tag >=", value, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagLessThan(String value) {
            addCriterion("promotion_tag <", value, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagLessThanOrEqualTo(String value) {
            addCriterion("promotion_tag <=", value, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagLike(String value) {
            addCriterion("promotion_tag like", value, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagNotLike(String value) {
            addCriterion("promotion_tag not like", value, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagIn(List<String> values) {
            addCriterion("promotion_tag in", values, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagNotIn(List<String> values) {
            addCriterion("promotion_tag not in", values, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagBetween(String value1, String value2) {
            addCriterion("promotion_tag between", value1, value2, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andPromotionTagNotBetween(String value1, String value2) {
            addCriterion("promotion_tag not between", value1, value2, "promotionTag");
            return (Criteria) this;
        }

        public Criteria andSevenReturnIsNull() {
            addCriterion("seven_return is null");
            return (Criteria) this;
        }

        public Criteria andSevenReturnIsNotNull() {
            addCriterion("seven_return is not null");
            return (Criteria) this;
        }

        public Criteria andSevenReturnEqualTo(Boolean value) {
            addCriterion("seven_return =", value, "sevenReturn");
            return (Criteria) this;
        }

        public Criteria andSevenReturnNotEqualTo(Boolean value) {
            addCriterion("seven_return <>", value, "sevenReturn");
            return (Criteria) this;
        }

        public Criteria andSevenReturnGreaterThan(Boolean value) {
            addCriterion("seven_return >", value, "sevenReturn");
            return (Criteria) this;
        }

        public Criteria andSevenReturnGreaterThanOrEqualTo(Boolean value) {
            addCriterion("seven_return >=", value, "sevenReturn");
            return (Criteria) this;
        }

        public Criteria andSevenReturnLessThan(Boolean value) {
            addCriterion("seven_return <", value, "sevenReturn");
            return (Criteria) this;
        }

        public Criteria andSevenReturnLessThanOrEqualTo(Boolean value) {
            addCriterion("seven_return <=", value, "sevenReturn");
            return (Criteria) this;
        }

        public Criteria andSevenReturnIn(List<Boolean> values) {
            addCriterion("seven_return in", values, "sevenReturn");
            return (Criteria) this;
        }

        public Criteria andSevenReturnNotIn(List<Boolean> values) {
            addCriterion("seven_return not in", values, "sevenReturn");
            return (Criteria) this;
        }

        public Criteria andSevenReturnBetween(Boolean value1, Boolean value2) {
            addCriterion("seven_return between", value1, value2, "sevenReturn");
            return (Criteria) this;
        }

        public Criteria andSevenReturnNotBetween(Boolean value1, Boolean value2) {
            addCriterion("seven_return not between", value1, value2, "sevenReturn");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}